/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package it.barattando.servlet;

import it.barattando.bean.DbController;
import it.barattando.bean.Oggetto;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.LinkedList;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 *
 * @author carlo.bison
 */
public class NuovoOggettoServlet extends HttpServlet {
    
    DbController controller;
    
    
    public void creaDbController() throws NamingException, SQLException{
            System.out.println("creazione oggetto dbAccess");
            controller= new DbController("jdbc/taksun");
            System.out.println("oggetto creato");
        
    }

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        
        HttpSession session=request.getSession();
        
        try{
            this.creaDbController();
        String user = (String)session.getAttribute("utente");
        String nome = request.getParameter("nome");
        String descrizione = request.getParameter("descrizione");
        String categoria = request.getParameter("categoria");
        String valore = request.getParameter("crediti");
        boolean res;
        
        System.out.println("utente= "+user+" nome= "+nome+" descrizione= "+descrizione+" categoria= "+categoria+" valore= "+valore);
        
        Oggetto nuovoOggetto=new Oggetto(nome,descrizione,categoria,valore,user);
        
        
            res=controller.inserisciNuovoOggetto(nuovoOggetto, user);
            System.out.println("risultato query inserimento: "+res);
            LinkedList<Oggetto> listaOggetti = this.controller.getOggetti(user);
                
                session.setAttribute("listaOggetti",listaOggetti);
            this.getServletContext().getRequestDispatcher("/listaOggetti.jsp").forward(request, response);
        } catch (SQLException ex) {
            System.out.println("Eccezione: "+ex.getLocalizedMessage());
            session.setAttribute("errorMessage", ex.getLocalizedMessage());
            this.getServletContext().getRequestDispatcher("/error.jsp").forward(request, response);
        } catch (NamingException ex) {
            System.out.println("Eccezione: "+ex.getLocalizedMessage());
            session.setAttribute("errorMessage", ex.getLocalizedMessage());
            this.getServletContext().getRequestDispatcher("/error.jsp").forward(request, response);
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP
     * <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP
     * <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}
